SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'city';Code language: SQL (Structured Query Language) (sql)
SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'city';